UKCPR National Welfare Data, 1980-2015
Arun, Colin, Hongchao, Jack
Introduction
We explore the dataset that we got from http://www.ukcpr.org/data. The data is from The University of Kentucky Center for Poverty Research. It contains state-level panel data series covering population, employment, unemployment, welfare, poverty, and politics from 1980-2015. These data are publically available to all users.
Look at our ReadMe file to see how to access the data we used.
R Configuration
Below we display our sessionInfo().
sessionInfo(package=NULL)## R version 3.3.2 (2016-10-31)
## Platform: x86_64-apple-darwin13.4.0 (64-bit)
## Running under: OS X El Capitan 10.11.6
##
## locale:
## [1] C
##
## attached base packages:
## [1] stats graphics grDevices utils datasets methods base
##
## loaded via a namespace (and not attached):
## [1] backports_1.0.5 magrittr_1.5 rprojroot_1.2 tools_3.3.2
## [5] htmltools_0.3.5 yaml_2.1.14 Rcpp_0.12.10 stringi_1.1.2
## [9] rmarkdown_1.3 knitr_1.15.1 stringr_1.1.0 digest_0.6.11
## [13] evaluate_0.10Tableau Visualizations
This is a barchart with Employment on the Columns and State, filtered by year, on the rows. The black line is the state aggregated employment average, so the bars that pass the black line show that during that year, the employment number passed the employment state average for all the years. The red and blue color coding represents whether the employment number passed the national aggregated employment average. The difference between a certain year’s employment in that state and the national average is shown as the numbers next to the bars.
The graph is a ID set, the graph shows the gross state products among all 50 states. There are two sets, one is high gross state product, and another one medium gross state product. The darker the blue dot means a higher gross state product percentage. One can see from the graph that northeastern states have higher gross state product percentages.
This is a map of all the states with their worker’s compensation vs income. The darker the color of the state means that the employees got more worker’s compensation for the amount they made. It’s interesting to note that working on the west region of the United States gives the best worker’s compensation. Working in the central region of the United States results in poor worker’s compensation for the income rate.
Shiny Application
The above shiny visulization shows the same results as the Tableau version of the barchart.
The above shiny visulization shows the same results as the Tableau version of the ID set. It colors each state based on high or low GSP.
The above shiny visulization shows the same results as the Tableau version of the map.
Link to Shiny Application
Here is the website to the shiny application : https://tesseract2010.shinyapps.io/project6/